package order;

import common.db.*;
import common.main.*;

public class BasketUseYnBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String code = (String)inputTable.get("code");
		String user_id = (String)inputTable.get("user_id");
		String client = (String)inputTable.get("client");
		String wbfrom = (String)inputTable.get("wbfrom");

		System.out.println("code : "+code);
		if(code==null)
		{
			queryBuffer = new StringBuffer("");
			queryBuffer.append("UPDATE ORDERLIST SET USE_YN='N', UPD_ID='" + user_id + "', UPD_DATE=SYSDATE, UPD_IP='" + client + "' WHERE ORDER_STATE=1");

			DBExecute dbe = new DBExecute(queryBuffer.toString());
			outputList = dbe.getDataList();		
		}
		else
		{

			queryBuffer = new StringBuffer("");
			queryBuffer.append("UPDATE ORDERLIST SET USE_YN='N', UPD_ID='" + user_id + "', UPD_DATE=SYSDATE, UPD_IP='" + client + "' WHERE CODE='" + code + "'");
	
			DBExecute dbe = new DBExecute(queryBuffer.toString());
			outputList = dbe.getDataList();
			

		}
	}
}